John Jonassen ✭✭✭✭

Overview

Overview

Roles	Member
Badges	15

About Me

About Me

Not much happening here, yet.

Analytics

140

Posts

347

Visits

250

Points

May 19, 2020

Join Date

Aug 29, 2024

Last Active

Reactions

• Insightful 5

  5
• Vote Up 8

  8

• Activity
• Discussions3
• Comments137

• Re: COUNTIF to determine the number of tickets created in a given month.

  John Jonassen

  09/24/20
  Try this: =COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))
  2 ·

• Re: Countifs with ranges from different docs

  John Jonassen

  09/08/20
  Yeah what @Javier Arbelaez stated. =COUNTIF({Sheet1/Range1}, [Email Address]1)+COUNTIF({Sheet2/Range1}, [Email Address]1)
  1 ·

• Re: IF statement with an OR....

  John Jonassen

  08/13/20
  Can you create a specific sheet that will serve as a lookup table for all Previous Base/Base combinations that includes a helper column concatenating the two together, then a CPO column that you defi…
  1 ·

Previous